from . import db
from sqlalchemy.dialects.mysql import INTEGER
from datetime import datetime


class DangerFuture(db.Model):
    __tablename__ = 'danger_future'

    id = db.Column(INTEGER(unsigned=True), primary_key=True, autoincrement=True)
    chart_data = db.Column(db.Text, nullable=False)
    start_data = db.Column(db.String(50), nullable=False)
    end_data = db.Column(db.String(50), nullable=False)
    min_data = db.Column(db.Float, nullable=False)
    max_data = db.Column(db.Float, nullable=False)
    report_content = db.Column(db.Text, nullable=True)

    # 如果有其他字段，请添加
